**************************************************************************************
* Bemærk at denne fil kun er til orientering om databaseændringer til denne release. *
* Filen MÅ IKKE afvikles!                                                            *
**************************************************************************************


IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'WebBrugerIndstillinger' and role = 'afdeling') THEN 
   ALTER TABLE WebBrugerIndstillinger DROP FOREIGN KEY afdeling;
   ALTER TABLE WebBrugerIndstillinger ADD FOREIGN KEY afdeling(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;


IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'SystemIndstillinger' and role = 'Institution_UniC') THEN 
   ALTER TABLE SystemIndstillinger DROP FOREIGN KEY Institution_UniC;
   ALTER TABLE SystemIndstillinger ADD FOREIGN KEY Institution_UniC(uniLoginInstitutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;


IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'WebKarakter' and role = 'afdeling') THEN 
   ALTER TABLE WebKarakter DROP FOREIGN KEY afdeling;
   ALTER TABLE WebKarakter ADD FOREIGN KEY afdeling(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'CensorLogin' and role = 'institution') THEN 
   ALTER TABLE CensorLogin DROP FOREIGN KEY institution;
   ALTER TABLE CensorLogin ADD FOREIGN KEY institution(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE ON DELETE SET NULL;
END IF;


IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AmuAktLinie' and role = 'afdeling') THEN 
   ALTER TABLE AmuAktLinie DROP FOREIGN KEY afdeling;
   ALTER TABLE AmuAktLinie ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;


IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AmuAktLinie' and role = 'afholdendeSkole') THEN 
   ALTER TABLE AmuAktLinie DROP FOREIGN KEY afholdendeSkole;
   ALTER TABLE AmuAktLinie ADD FOREIGN KEY afholdendeSkole(afholdendeSkoleKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AuAktLinie' and role = 'afdeling') THEN 
   ALTER TABLE AuAktLinie DROP FOREIGN KEY afdeling;
   ALTER TABLE AuAktLinie ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AuAktLinie' and role = 'afholdendeSkole') THEN 
   ALTER TABLE AuAktLinie DROP FOREIGN KEY afholdendeSkole;
   ALTER TABLE AuAktLinie ADD FOREIGN KEY afholdendeSkole(afholdendeSkoleKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'EudBevisKarakter' and role = 'institutionFK') THEN 
   ALTER TABLE EudBevisKarakter DROP FOREIGN KEY institutionFK;
   ALTER TABLE EudBevisKarakter ADD FOREIGN KEY institutionFK(afholdendeSkoleKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AuDeltagerbetalingRefusion' and role = 'afdeling') THEN 
   ALTER TABLE AuDeltagerbetalingRefusion DROP FOREIGN KEY afdeling;
   ALTER TABLE AuDeltagerbetalingRefusion ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'AuDeltagerbetalingRefusion' and role = 'afholdendeSkole') THEN 
   ALTER TABLE AuDeltagerbetalingRefusion DROP FOREIGN KEY afholdendeSkole;
   ALTER TABLE AuDeltagerbetalingRefusion ADD FOREIGN KEY afholdendeSkole(afholdendeSkoleKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'SkolepraktikAktLinieIndhold' and role = 'afdeling') THEN 
   ALTER TABLE SkolepraktikAktLinieIndhold DROP FOREIGN KEY afdeling;
   ALTER TABLE SkolepraktikAktLinieIndhold ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'SkolepraktikAktLinie' and role = 'afdeling') THEN 
   ALTER TABLE SkolepraktikAktLinie DROP FOREIGN KEY afdeling;
   ALTER TABLE SkolepraktikAktLinie ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'FuldtidAktLinieIndhold' and role = 'afdeling') THEN 
   ALTER TABLE FuldtidAktLinieIndhold DROP FOREIGN KEY afdeling;
   ALTER TABLE FuldtidAktLinieIndhold ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'FuldtidAktLinie' and role = 'afdeling') THEN 
   ALTER TABLE FuldtidAktLinie DROP FOREIGN KEY afdeling;
   ALTER TABLE FuldtidAktLinie ADD FOREIGN KEY afdeling(afdelingKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'Uddannelsesforloeb' and role = 'afdeling') THEN 
   ALTER TABLE Uddannelsesforloeb DROP FOREIGN KEY afdeling;
   ALTER TABLE Uddannelsesforloeb ADD FOREIGN KEY afdeling(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'EudBevis' and role = 'institutionFK') THEN 
   ALTER TABLE EudBevis DROP FOREIGN KEY institutionFK;
   ALTER TABLE EudBevis ADD FOREIGN KEY institutionFK(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;
END IF;

IF EXISTS (SELECT 1 FROM SYSFOREIGNKEYS WHERE foreign_tname = 'Elevforloeb' and role = 'institution') THEN 
   ALTER TABLE Elevforloeb DROP FOREIGN KEY institution;
END IF;
ALTER TABLE Elevforloeb ADD FOREIGN KEY institution(institutionKode) REFERENCES Institution(institutionKode) ON UPDATE CASCADE;


IF NOT EXISTS (SELECT 1 FROM SYS.SYSCOLUMNS WHERE tname = 'FtuAnsoegning' AND cname = 'ansoegerFoedselsdato') THEN
  ALTER TABLE FtuAnsoegning ADD ansoegerFoedselsdato DATE NULL;
END IF;

;COMMIT;QUIT;